
DECLARE @role_id INT
INSERT INTO [cg_security].[dbo].[cg_security_role] ([role_name],[role_description]) VALUES ('SecurityAdmin', 'The CG.Security Admin Role')
SELECT @role_id = SCOPE_IDENTITY()

DECLARE @user_id INT
INSERT INTO [cg_security].[dbo].[cg_security_user] ([user_name],[user_pwd],[create_date]) VALUES('Admin', 'B45668EDFA23D0A2E3A68C7A78858188E9291FB4', GetDate())
SELECT @user_id = SCOPE_IDENTITY()

INSERT INTO [cg_security].[dbo].[cg_security_user_role] ([user_id],[role_id]) VALUES (@user_id, @role_id)
